Learn about various data engineering patterns that use batch scheduling within Azure Databricks with Spark Dataframes.
The post Engineering a Lakehouse with Azure Databricks with Spark Dataframes appeared first on MSSQLTips.com.
Learn about a more robust and resilient way to implement log shipping for SQL Server including easy failover and failback.
The post Beyond Log Shipping, a Smarter Approach to DR appeared first on MSSQLTips.com.
In this article, I describe how data storage can be managed when the data exists as files in Microsoft Fabric Lakehouse.
The post Data Retention Management for Lakehouse Files in Microsoft Fabric appeared first on MSSQLTips.com.
In this article, we look at how you can create a chatbot using Azure AI Search along with OpenAI Studio to create a custom chatbot.
The post Creating a Chatbot with Azure AI Search and OpenAI Studio appeared first on MSSQLTips.com.
Throughout this series, I’ve introduced you to different features in MongoDB and provided examples to help demonstrate how the database system works. The examples have all been based on conventional collections, the type that MongoDB creates by default. However, MongoDB also supports other types of collections, including the time series collection, which can benefit many...…
The post Creating Time Series Collections in MongoDB appeared first on Simple Talk.
Learn how to calculate the difference between two points on the globe using SQL code along with several examples and explanations.
The post Calculate Distance Between Two Points with SQL appeared first on MSSQLTips.com.
I spent a few weeks away from the office in early January, just like last year, mostly on vacation. Something I started to do last year was to take some of my away-from-office time and do some writing, in particular, editorials for the year. I have to write quite a few of these, and it...…
The post Weekly Blogging appeared first on Simple Talk.
There is a feature of SQL I have not seen used much and probably with good reason. It’s the use of temporary tables. These are declared with the expected DDL. Since they were relatively easy to add to the language, they have been around for a while. The bad news is that in the early...…
The post Temporary Tables appeared first on Simple Talk.
Problem Changes in tables, views, store procedures, and user defined functions are done routinely in SQL Server. Is it possible to use a tool like Azure DevOps in…
The post Database Version Control with Git in Azure DevOps appeared first on MSSQLTips.com.
Learning from your mistakes is a very powerful method of improving your skills, but also a costly path. Do you know what’s better? Learning from mine! Join to…
The post Things I Wish I Knew as a DBA appeared first on MSSQLTips.com.
DreamFactory sponsored on-demand webinar DreamFactory is an API management platform best known for its ability to generate REST APIs for a wide variety of data sources, including Microsoft SQL…
The post Build SQL Server APIs Rapidly appeared first on MSSQLTips.com.
DreamFactory sponsored on-demand webinar SSIS is the de facto solution for SQL Server data integration and transformation. However, standard ETL processes are typically slow and result in data…
The post A Powerful and Secure Alternative to SSIS appeared first on MSSQLTips.com.
Webcast Abstract Ensuring high availability for SQL Server is critical for minimizing downtime and protecting business-critical data. In this webinar, we will explore key high availability considerations for…
The post Mastering High Availability for On-Prem SQL Server appeared first on MSSQLTips.com.
Before jumping into the news and code, let’s start from the beginning: Why does someone use Azure SQL Serverless? The answer is simple: Save money. Considering my personal scenario, I can think about at least two different scenarios related to saving money. In my personal scenario, I have lots of sample databases. Using the lowest...…
The post Azure SQL Serverless: Discover What’s new and Increase Your Savings appeared first on Simple Talk.
The data transformation tool dbt (data build tool) has become more and more popular over the past years. It focuses heavily on SQL, and it adds a bunch of interesting features into the mix, such as data lineage, automatic orchestration, reusable macros etc. In the first article in this series, A gentle introduction to dbt,...…
The post Loading Models from Source Data with dbt appeared first on Simple Talk.
Part 2 in the series: A Comprehensive Beginners Guide to Configuration with MySQL Shell. In the first part of the series article, we introduced MySQL Shell as a tool for managing and optimizing MySQL configurations. We discussed how to install the Shell, connect to the MySQL server, and modify basic configuration parameters. Now, we’re into...…
The post MySQL Shell and Basic Configuration Management (Part 2 – Memory and CPU) appeared first on Simple Talk.